﻿CREATE TABLE [dbo].[Statistics_Financial] (
    [Id]                 INT             IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [CompanyId]          INT             NULL,
    [CompanyName]        NVARCHAR (50)   NULL,
    [OAA]                DECIMAL (18, 2) NULL,
    [OAB]                DECIMAL (18, 2) NULL,
    [OBA]                DECIMAL (18, 2) NULL,
    [OBB]                DECIMAL (18, 2) NULL,
    [OBC]                DECIMAL (18, 2) NULL,
    [OBD]                DECIMAL (18, 2) NULL,
    [OBE]                DECIMAL (18, 2) NULL,
    [OBF]                DECIMAL (18, 2) NULL,
    [OBG]                DECIMAL (18, 2) NULL,
    [OBH]                DECIMAL (18, 2) NULL,
    [OCA]                DECIMAL (18, 2) NULL,
    [OCB]                DECIMAL (18, 2) NULL,
    [OCC]                DECIMAL (18, 2) NULL,
    [ODA]                DECIMAL (18, 2) NULL,
    [ODB]                DECIMAL (18, 2) NULL,
    [IAA]                DECIMAL (18, 2) NULL,
    [IAB]                DECIMAL (18, 2) NULL,
    [IAC]                DECIMAL (18, 2) NULL,
    [IAD]                DECIMAL (18, 2) NULL,
    [IAE]                DECIMAL (18, 2) NULL,
    [IAF]                DECIMAL (18, 2) NULL,
    [IAG]                DECIMAL (18, 2) NULL,
    [IBA]                DECIMAL (18, 2) NULL,
    [IBB]                DECIMAL (18, 2) NULL,
    [IBC]                DECIMAL (18, 2) NULL,
    [IBD]                DECIMAL (18, 2) NULL,
    [IBDA]               DECIMAL (18, 2) NULL,
    [IBDB]               DECIMAL (18, 2) NULL,
    [IBE]                DECIMAL (18, 2) NULL,
    [IBEA]               DECIMAL (18, 2) NULL,
    [IBEB]               DECIMAL (18, 2) NULL,
    [IBF]                DECIMAL (18, 2) NULL,
    [IBG]                DECIMAL (18, 2) NULL,
    [IBH]                DECIMAL (18, 2) NULL,
    [IBHA]               DECIMAL (18, 2) NULL,
    [IBHB]               DECIMAL (18, 2) NULL,
    [IBI]                DECIMAL (18, 2) NULL,
    [IBIA]               DECIMAL (18, 2) NULL,
    [IBIB]               DECIMAL (18, 2) NULL,
    [IBJ]                DECIMAL (18, 2) NULL,
    [IBK]                DECIMAL (18, 2) NULL,
    [IBL]                DECIMAL (18, 2) NULL,
    [CreateDate]         DATETIME        NULL,
    [CreateUser]         NVARCHAR (50)   NULL,
    [OEA]                DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_OEA] DEFAULT ((0)) NULL,
    [OEB]                DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_OEB] DEFAULT ((0)) NULL,
    [OEC]                DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_OEC] DEFAULT ((0)) NULL,
    [OED]                DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_OED] DEFAULT ((0)) NULL,
    [OEE]                DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_OEE] DEFAULT ((0)) NULL,
    [OEF]                DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_OEF] DEFAULT ((0)) NULL,
    [OEG]                DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_OEG] DEFAULT ((0)) NULL,
    [OEH]                DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_OEH] DEFAULT ((0)) NULL,
    [OEI]                DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_OEI] DEFAULT ((0)) NULL,
    [OEJ]                DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_OEJ] DEFAULT ((0)) NULL,
    [OEK]                DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_OEK] DEFAULT ((0)) NULL,
    [OEL]                DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_OEL] DEFAULT ((0)) NULL,
    [OEM]                DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_OEM] DEFAULT ((0)) NULL,
    [OEN]                DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_OEN] DEFAULT ((0)) NULL,
    [OEO]                DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_OEO] DEFAULT ((0)) NULL,
    [OEP]                DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_OEP] DEFAULT ((0)) NULL,
    [OEQ]                DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_OEQ] DEFAULT ((0)) NULL,
    [OER]                DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_OER] DEFAULT ((0)) NULL,
    [OES]                DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_OES] DEFAULT ((0)) NULL,
    [bd]                 INT             CONSTRAINT [DF_Statistics_Financial_bd] DEFAULT ((0)) NULL,
    [bd_je]              DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_bd_je] DEFAULT ((0)) NULL,
    [wz]                 INT             CONSTRAINT [DF_Statistics_Financial_wz] DEFAULT ((0)) NULL,
    [wz_je]              DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_wz_je] DEFAULT ((0)) NULL,
    [qyQQ]               INT             CONSTRAINT [DF_Statistics_Financial_qyQQ] DEFAULT ((0)) NULL,
    [qyQQ_je]            DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_qyQQ_je] DEFAULT ((0)) NULL,
    [qt]                 INT             CONSTRAINT [DF_Statistics_Financial_qt] DEFAULT ((0)) NULL,
    [qt_je]              DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_qt_je] DEFAULT ((0)) NULL,
    [IDC]                INT             CONSTRAINT [DF_Statistics_Financial_IDC] DEFAULT ((0)) NULL,
    [IDC_je]             DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_IDC_je] DEFAULT ((0)) NULL,
    [xzxse]              DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_xzxse] DEFAULT ((0)) NULL,
    [xfxse]              DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_xfxse] DEFAULT ((0)) NULL,
    [rcfy]               DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_rcfy] DEFAULT ((0)) NULL,
    [yggz]               DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_yggz] DEFAULT ((0)) NULL,
    [sf]                 DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_sf] DEFAULT ((0)) NULL,
    [ff]                 DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_ff] DEFAULT ((0)) NULL,
    [zbfy]               DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_zbfy] DEFAULT ((0)) NULL,
    [ygfl]               DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_ygfl] DEFAULT ((0)) NULL,
    [sjglf]              DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_sjglf] DEFAULT ((0)) NULL,
    [qtzc]               DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_qtzc] DEFAULT ((0)) NULL,
    [fyze]               DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_fyze] DEFAULT ((0)) NULL,
    [fyyxsr]             DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_fyyxsr] DEFAULT ((0)) NULL,
    [jkzc]               DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_jkzc] DEFAULT ((0)) NULL,
    [jksr]               DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_jksr] DEFAULT ((0)) NULL,
    [dkzc]               DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_dkzc] DEFAULT ((0)) NULL,
    [dksr]               DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_dksr] DEFAULT ((0)) NULL,
    [tzzc]               DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_tzzc] DEFAULT ((0)) NULL,
    [tzsr]               DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_tzsr] DEFAULT ((0)) NULL,
    [fh]                 DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_fh] DEFAULT ((0)) NULL,
    [ssclwsr]            DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_ssclwsr] DEFAULT ((0)) NULL,
    [ssclwzc]            DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_ssclwzc] DEFAULT ((0)) NULL,
    [cl]                 DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_cl] DEFAULT ((0)) NULL,
    [sscl]               DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_sscl] DEFAULT ((0)) NULL,
    [zxf]                DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_zxf] DEFAULT ((0)) NULL,
    [gdzc]               DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_gdzc] DEFAULT ((0)) NULL,
    [jj]                 DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_jjbcfk] DEFAULT ((0)) NULL,
    [bcfk]               DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_bcfk] DEFAULT ((0)) NULL,
    [kqfk]               DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_kqfk] DEFAULT ((0)) NULL,
    [qqqdfqzcxse]        DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_qqqdfqzcxse] DEFAULT ((0)) NULL,
    [qqqdfqzcml]         DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_FQZC] DEFAULT ((0)) NULL,
    [qqqd]               DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_QQQD] DEFAULT ((0)) NULL,
    [bdztc]              INT             CONSTRAINT [DF_Statistics_Financial_BDZTC] DEFAULT ((0)) NULL,
    [bdztcxse]           DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_BDZTCXSE] DEFAULT ((0)) NULL,
    [QYQQ_CustomerCount] INT             NULL,
    CONSTRAINT [PK_Statistics_Financial] PRIMARY KEY CLUSTERED ([Id] ASC)
);


GO
CREATE NONCLUSTERED INDEX [IX_Statistics_Financial]
    ON [dbo].[Statistics_Financial]([CompanyId] ASC);


GO
CREATE NONCLUSTERED INDEX [IX_Statistics_Financial_1]
    ON [dbo].[Statistics_Financial]([CreateDate] ASC);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'往来借款', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'OCC';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'员工工资', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'OEA';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'保险', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'OEB';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'税金', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'OEC';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'房费', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'OED';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'电话宽带费', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'OEE';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'水电费', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'OEF';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'办公费用', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'OEG';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'车辆费', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'OEH';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'差旅费', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'OEI';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'招待费', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'OEJ';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'财务费用', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'OEK';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'招聘费', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'OEL';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'装修费', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'OEM';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'市场宣传费', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'OEN';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'员工福利', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'OEO';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'基金支出', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'OEP';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'其他支出', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'OEQ';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'上缴资金', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'OER';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'其他成本支出', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'OES';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'百度数', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'bd';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'网站数', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'wz';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'企业QQ', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'qyQQ';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'其他数', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'qt';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'其他产品销售额', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'qt_je';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'IDC产品单数', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'IDC';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'IDC产品销售额', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'IDC_je';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'新增销售额', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'xzxse';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'续费销售额', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'xfxse';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'日常费用', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'rcfy';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'员工工资', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'yggz';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'税费', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'sf';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'房费', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'ff';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'总办费用', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'zbfy';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'员工福利', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'ygfl';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'上缴管理费', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'sjglf';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'其他支出', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'qtzc';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'费用总额', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'fyze';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'非营业性收入', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'fyyxsr';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'借款支出', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'jkzc';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'借款收入', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'jksr';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'调款支出', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'dkzc';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'调款收入', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'dksr';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'投资支出', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'tzzc';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'投资收入', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'tzsr';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'分红', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'fh';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'实收纯利外收入', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'ssclwsr';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'实收纯利外支出', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'ssclwzc';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'纯利', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'cl';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'实收纯利', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'sscl';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'固定资产支出(176)及装修费(159)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'zxf';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'固定资产', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'gdzc';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'奖金补偿返款 2015.1.29 新增', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial', @level2type = N'COLUMN', @level2name = N'jj';

